package cn.com.api.mapper.base;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import cn.com.api.entity.ApiT_member_wemedia;

//DAO
public interface T_member_wemediaMapperBase {

	// 根据id查看
	@Select("SELECT * FROM T_MEMBER_WEMEDIA  WHERE ID = #{ID}")
	public ApiT_member_wemedia findT_member_wemediaById(Integer id);

	// 查看数据集
	@Select("SELECT * FROM T_member_wemedia")
	public List<ApiT_member_wemedia> findT_member_wemedias();

	// 添加
	public int insertT_member_wemedia(ApiT_member_wemedia t_member_wemedia);

	// 修改
	@Update("UPDATE T_MEMBER_WEMEDIA SET USER_ID = #{user_id,jdbcType=INTEGER}, MEDIA_PROPERTY = #{media_property,jdbcType=VARCHAR}, MEDIA_TITLE = #{media_title,jdbcType=VARCHAR}, MEDIA_DESC = #{media_desc,jdbcType=VARCHAR}, MEDIA_HEADER = #{media_header,jdbcType=VARCHAR}, MATERIAL = #{material,jdbcType=VARCHAR}, ORG_NAME = #{org_name,jdbcType=VARCHAR}, ORG_CODE = #{org_code,jdbcType=VARCHAR}, LETTER_SCAN = #{letter_scan,jdbcType=VARCHAR}, WEB_URL = #{web_url,jdbcType=VARCHAR}, MEDIA_URL = #{media_url,jdbcType=VARCHAR}, ADDRESS = #{address,jdbcType=VARCHAR}, FIELD = #{field,jdbcType=VARCHAR}, CONNECTOR = #{connector,jdbcType=VARCHAR}, STATION = #{station,jdbcType=VARCHAR}, MOBILE = #{mobile,jdbcType=VARCHAR}, EMAIL = #{email,jdbcType=VARCHAR}, CONNECTOR_ID = #{connector_id,jdbcType=VARCHAR}, CONNECTOR_FRONT = #{connector_front,jdbcType=VARCHAR}, CONNECTOR_BACK = #{connector_back,jdbcType=VARCHAR}, APPLY_TIME = #{apply_time,jdbcType=VARCHAR}, UPDATE_UID = #{update_uid,jdbcType=INTEGER}, STATUS = #{status,jdbcType=INTEGER}, REASON = #{reason,jdbcType=VARCHAR},media_mobile = #{media_mobile,jdbcType=VARCHAR}, consignment_img = #{consignment_img,jdbcType=VARCHAR} WHERE ID = #{id}")
	public int updateT_member_wemedia(ApiT_member_wemedia t_member_wemedia);

	// 删除
	@Delete("DELETE FROM T_MEMBER_WEMEDIA  WHERE ID = #{ID}")
	public int deleteT_member_wemedia(Integer id);

	// Foreign keys revelant

	// region Indexs revelant

}
